package jpa.entitys.promis.sales;

import java.io.Serializable;

import javax.persistence.*;

import java.math.BigDecimal;
import java.util.Date;


/**
 * The persistent class for the MKT_BANKFORM_REQUEST database table.
 * 
 */
@Entity
@Table(name="MKT_BANKFORM_REQUEST")
@NamedQueries({
    @NamedQuery(name = "MktBankformRequest.findAll", query = " SELECT c FROM MktBankformRequest c "),
    @NamedQuery(name = "MktBankformRequest.findById", query = " SELECT c FROM MktBankformRequest c WHERE c.id = :Id "),
    @NamedQuery(name = "MktBankformRequest.findByStaging", query = " SELECT c FROM MktBankformRequest c WHERE c.syncIsstaging = :syncIsstaging")
})
public class MktBankformRequest extends jpa.entitys.common.CommonEntity implements Serializable {
	private static final long serialVersionUID = 1L;

	@EmbeddedId
	private MktBankformRequestPK id;
	
	@Override public String toString() { return org.apache.commons.lang.builder.ToStringBuilder.reflectionToString(this);}

	@Column(name="ACCOUNT_NAME", length=300)
	private String accountName;

	@Column(name="APPROVED_FLAG", length=1)
	private String approvedFlag;

	@Column(name="BAK_ACCOUNT_NO", length=30)
	private String bakAccountNo;

	@Column(name="BANK_AC_TYPE")
	private String bankAcType;

	@Column(name="BANK_ACCOUNT_NO", length=30)
	private String bankAccountNo;

	@Column(name="BANK_BRANCH_CODE", length=30)
	private String bankBranchCode;

	@Column(name="BANK_BRANCH_NAME", length=300)
	private String bankBranchName;

	@Column(name="BANK_CODE", length=30)
	private String bankCode;

	@Column(name="BANK_NAME", length=300)
	private String bankName;

	@Column(name="BANK_NUMBER", length=50)
	private String bankNumber;

	@Column(name="CREATED_BY")
	private String createdBy;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="CREATED_ON")
	private Date createdOn;

	@Column(name="CUSTOMER_CODE", length=30)
	private String customerCode;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="DATE_FOR_DEDUCT")
	private Date dateForDeduct;

	@Column(name="DEDUCT_AMOUNT", precision=16, scale=2)
	private BigDecimal deductAmount;

	@Column(name="DEDUCT_PERIOD", precision=16, scale=2)
	private BigDecimal deductPeriod;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="END_PAY")
	private Date endPay;

	@Column(name="LAST_UPD_BY")
	private String lastUpdBy;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="LAST_UPD_ON")
	private Date lastUpdOn;

	@Column(length=500)
	private String remarks;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="REQUEST_DATE")
	private Date requestDate;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="START_PAY")
	private Date startPay;

	@Column(length=1)
	private String status;

	@Column(name="SYNC_CREATEDBY", length=100)
	private String syncCreatedby;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="SYNC_CREATEDON")
	private Date syncCreatedon;

	@Column(name="SYNC_EXTERNAL_REF_KEY", length=100)
	private String syncExternalRefKey;

	@Column(name="SYNC_EXTERNAL_REF_NO", length=100)
	private String syncExternalRefNo;

	@Column(name="SYNC_ISSTAGING", length=1)
	private String syncIsstaging;

	@Column(name="SYNC_ISSYNC", length=1)
	private String syncIssync;

	@Column(name="SYNC_UPDATEDBY", length=100)
	private String syncUpdatedby;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="SYNC_UPDATEDON")
	private Date syncUpdatedon;

	@Column(name="UNIT_NUMBER", length=30)
	private String unitNumber;

	@Column(name="IS_INTERFACE")
	private String isInterface;

	public String getIsInterface() {
		return isInterface;
	}

	public void setIsInterface(String isInterface) {
		this.isInterface = isInterface;
	}
	
    public MktBankformRequest() {
    }

	public MktBankformRequestPK getId() {
		return this.id;
	}

	public void setId(MktBankformRequestPK id) {
		this.id = id;
	}
	
	public String getAccountName() {
		return this.accountName;
	}

	public void setAccountName(String accountName) {
		this.accountName = accountName;
	}

	public String getApprovedFlag() {
		return this.approvedFlag;
	}

	public void setApprovedFlag(String approvedFlag) {
		this.approvedFlag = approvedFlag;
	}

	public String getBakAccountNo() {
		return this.bakAccountNo;
	}

	public void setBakAccountNo(String bakAccountNo) {
		this.bakAccountNo = bakAccountNo;
	}

	public String getBankAcType() {
		return this.bankAcType;
	}

	public void setBankAcType(String bankAcType) {
		this.bankAcType = bankAcType;
	}

	public String getBankAccountNo() {
		return this.bankAccountNo;
	}

	public void setBankAccountNo(String bankAccountNo) {
		this.bankAccountNo = bankAccountNo;
	}

	public String getBankBranchCode() {
		return this.bankBranchCode;
	}

	public void setBankBranchCode(String bankBranchCode) {
		this.bankBranchCode = bankBranchCode;
	}

	public String getBankBranchName() {
		return this.bankBranchName;
	}

	public void setBankBranchName(String bankBranchName) {
		this.bankBranchName = bankBranchName;
	}

	public String getBankCode() {
		return this.bankCode;
	}

	public void setBankCode(String bankCode) {
		this.bankCode = bankCode;
	}

	public String getBankName() {
		return this.bankName;
	}

	public void setBankName(String bankName) {
		this.bankName = bankName;
	}

	public String getBankNumber() {
		return this.bankNumber;
	}

	public void setBankNumber(String bankNumber) {
		this.bankNumber = bankNumber;
	}

	public String getCreatedBy() {
		return this.createdBy;
	}

	public void setCreatedBy(String createdBy) {
		this.createdBy = createdBy;
	}

	public Date getCreatedOn() {
		return this.createdOn;
	}

	public void setCreatedOn(Date createdOn) {
		this.createdOn = createdOn;
	}

	public String getCustomerCode() {
		return this.customerCode;
	}

	public void setCustomerCode(String customerCode) {
		this.customerCode = customerCode;
	}

	public Date getDateForDeduct() {
		return this.dateForDeduct;
	}

	public void setDateForDeduct(Date dateForDeduct) {
		this.dateForDeduct = dateForDeduct;
	}

	public BigDecimal getDeductAmount() {
		return this.deductAmount;
	}

	public void setDeductAmount(BigDecimal deductAmount) {
		this.deductAmount = deductAmount;
	}

	public BigDecimal getDeductPeriod() {
		return this.deductPeriod;
	}

	public void setDeductPeriod(BigDecimal deductPeriod) {
		this.deductPeriod = deductPeriod;
	}

	public Date getEndPay() {
		return this.endPay;
	}

	public void setEndPay(Date endPay) {
		this.endPay = endPay;
	}

	public String getLastUpdBy() {
		return this.lastUpdBy;
	}

	public void setLastUpdBy(String lastUpdBy) {
		this.lastUpdBy = lastUpdBy;
	}

	public Date getLastUpdOn() {
		return this.lastUpdOn;
	}

	public void setLastUpdOn(Date lastUpdOn) {
		this.lastUpdOn = lastUpdOn;
	}

	public String getRemarks() {
		return this.remarks;
	}

	public void setRemarks(String remarks) {
		this.remarks = remarks;
	}

	public Date getRequestDate() {
		return this.requestDate;
	}

	public void setRequestDate(Date requestDate) {
		this.requestDate = requestDate;
	}

	public Date getStartPay() {
		return this.startPay;
	}

	public void setStartPay(Date startPay) {
		this.startPay = startPay;
	}

	public String getStatus() {
		return this.status;
	}

	public void setStatus(String status) {
		this.status = status;
	}

	public String getSyncCreatedby() {
		return this.syncCreatedby;
	}

	public void setSyncCreatedby(String syncCreatedby) {
		this.syncCreatedby = syncCreatedby;
	}

	public Date getSyncCreatedon() {
		return this.syncCreatedon;
	}

	public void setSyncCreatedon(Date syncCreatedon) {
		this.syncCreatedon = syncCreatedon;
	}

	public String getSyncExternalRefKey() {
		return this.syncExternalRefKey;
	}

	public void setSyncExternalRefKey(String syncExternalRefKey) {
		this.syncExternalRefKey = syncExternalRefKey;
	}

	public String getSyncExternalRefNo() {
		return this.syncExternalRefNo;
	}

	public void setSyncExternalRefNo(String syncExternalRefNo) {
		this.syncExternalRefNo = syncExternalRefNo;
	}

	public String getSyncIsstaging() {
		return this.syncIsstaging;
	}

	public void setSyncIsstaging(String syncIsstaging) {
		this.syncIsstaging = syncIsstaging;
	}

	public String getSyncIssync() {
		return this.syncIssync;
	}

	public void setSyncIssync(String syncIssync) {
		this.syncIssync = syncIssync;
	}

	public String getSyncUpdatedby() {
		return this.syncUpdatedby;
	}

	public void setSyncUpdatedby(String syncUpdatedby) {
		this.syncUpdatedby = syncUpdatedby;
	}

	public Date getSyncUpdatedon() {
		return this.syncUpdatedon;
	}

	public void setSyncUpdatedon(Date syncUpdatedon) {
		this.syncUpdatedon = syncUpdatedon;
	}

	public String getUnitNumber() {
		return this.unitNumber;
	}

	public void setUnitNumber(String unitNumber) {
		this.unitNumber = unitNumber;
	}

}